{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["PASO_1","Tend.","Incr.","Lineal","Tend_FORMULA","Incr_FORMULA","Lineal_FORMULA","PASO_3","Tend_Ej.","Incr_Ej.","Lineal_Ej.","Hoja2","Hoja9"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PASO_1","index":0,"n_rows":69,"n_cols":16,"rows_kept":69,"cut":false,"hidden":false,"merged":[[49,1,50,1],[46,3,46,12],[68,1,70,15],[19,1,20,15],[21,1,22,7],[21,9,22,15],[23,1,44,7],[23,9,44,15],[13,1,13,3],[13,4,13,15],[15,1,15,15],[17,1,18,1],[17,2,18,5],[17,6,18,15],[10,1,10,3],[10,4,10,15],[11,1,11,3],[11,4,11,15],[12,1,12,3],[12,4,12,15],[4,1,4,15],[6,1,6,15],[8,1,8,3],[8,4,8,15],[9,1,9,3],[9,4,9,15]]}
[]
[]
[]
[]
[null,"Plantilla para cálculo de metas"]
[]
[null,"Datos del indicador"]
[]
[null,"Nombre del indicador:"]
[null,"Nombre variable numerador:"]
[null,"Nombre variable denominador:"]
[null,"Método de cálculo"]
[null,"Programa donde se le da seguimiento:"]
[null,"Nivel del objetivo:"]
[]
[null,"Preguntas esenciales para la construcción de la meta"]
[]
[null,1,"¿Se cuenta con información histórica completa, incompleta o inexistente?"]
[]
[null,"Se puede utilizar alguno de estos métodos para estimar la meta"]
[]
[null,{"$f":"VLOOKUP($G$18,Hoja9!$C$3:$E$5,3,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$18,Hoja9!$C$3:$H$5,5,0)","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"VLOOKUP(B22,Hoja9!E3:F5,2,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,{"$f":"VLOOKUP(J22,Hoja9!G3:H5,2,0)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Visualizador gráfico de datos (Capturar datos)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"META"]
[null,"Capturar años de los cuales se tienen valores y de la meta deseada",null,null,null,null,null,null,null,null,null,null,null,null,null,2024]
[null,"Capturar valores históricos del numerador y denominador. O si desea encontrar la meta estimada de un valor absoluto, deje en blanco estas casillas y sólo capture los valores en la siguiente fila."]
[]
[null,"Capturar valores históricos o aplicar fórmula"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Plantilla elaborada por el Departamento de Evaluación a partir de la información contenida en la Guía para el establecimiento y cálculo de línea base y metas del CONEVAL (pg. 19-33) https://www.coneval.org.mx/coordinacion/Documents/monitoreo/metodologia/guia_lineas_base_metas.pdf"]

{"sheet":"Tend.","index":1,"n_rows":40,"n_cols":27,"rows_kept":40,"cut":false,"hidden":false,"merged":[[29,2,33,3],[29,5,33,5],[29,6,33,6],[29,8,33,8],[29,9,33,9],[30,13,32,13],[30,15,32,15],[32,11,33,11],[28,16,28,17],[29,11,30,11],[29,12,33,12],[29,14,33,14],[29,16,33,17],[17,19,18,19],[22,2,26,3],[22,5,26,5],[22,6,23,6],[22,8,26,8],[22,9,23,9],[22,11,26,11],[22,12,23,12],[22,14,23,14],[22,16,26,17],[23,13,25,13],[23,15,25,15],[25,6,26,6],[25,9,26,9],[25,12,26,12],[25,14,26,14],[10,1,14,1],[8,2,8,15],[9,2,9,15],[7,2,7,15],[1,1,1,15],[2,1,2,15],[4,2,4,15],[5,2,5,15],[6,2,6,15]]}
[]
[null,"Plantilla para cálculo de metas"]
[null,"Método de tendencias"]
[]
[null,"Nombre del indicador:",{"$f":"PASO_1!$E$9","v":0}]
[null,"Nombre variable numerador:",{"$f":"PASO_1!$E$10","v":0}]
[null,"Nombre variable denominador:",{"$f":"PASO_1!$E$11","v":0}]
[null,"Método de cálculo",{"$f":"PASO_1!$E$12","v":0}]
[null,"Programa donde se le da seguimiento:",{"$f":"PASO_1!$E$13","v":0}]
[null,"Nivel del objetivo:",{"$f":"PASO_1!$E$14","v":0}]
[null,"NOTA: Este método requiere:\n-Contar con datos inmediatos anteriores al año meta deseado;\n-Contar con una serie de datos sin huecos;\n-Que haya la misma cantidad de datos antes de la Línea Base como después.",null,null,null,null,null,null,null,null,null,null,null,null,null,"META",null,null,null,null,null,"Año","LB","Valor",null,"Meta","Año"]
[null,null,{"$f":"PASO_1!C49","v":0},{"$f":"PASO_1!D49","v":0},{"$f":"PASO_1!E49","v":0},{"$f":"PASO_1!F49","v":0},{"$f":"PASO_1!G49","v":0},{"$f":"PASO_1!H49","v":0},{"$f":"PASO_1!I49","v":0},{"$f":"PASO_1!J49","v":0},{"$f":"PASO_1!K49","v":0},{"$f":"PASO_1!L49","v":0},{"$f":"PASO_1!M49","v":0},{"$f":"PASO_1!N49","v":0},{"$f":"PASO_1!O49","v":0},{"$f":"PASO_1!P49","v":2024},null,null,null,null,null,{"$f":"$C$12","v":0},{"$f":"$C$16","v":0},{"$f":"$C$15","v":0},null,{"$f":"$C$17","v":0},{"$f":"$C$12","v":0}]
[null,null,{"$f":"PASO_1!C50","v":0},{"$f":"PASO_1!D50","v":0},{"$f":"PASO_1!E50","v":0},{"$f":"PASO_1!F50","v":0},{"$f":"PASO_1!G50","v":0},{"$f":"PASO_1!H50","v":0},{"$f":"PASO_1!I50","v":0},{"$f":"PASO_1!J50","v":0},{"$f":"PASO_1!K50","v":0},{"$f":"PASO_1!L50","v":0},{"$f":"PASO_1!M50","v":0},{"$f":"PASO_1!N50","v":0},{"$f":"PASO_1!O50","v":0},"x",null,null,null,null,null,{"$f":"$D$12","v":0},{"$f":"$D$16","v":0},{"$f":"$D$15","v":0},null,{"$f":"$D$17","v":0},{"$f":"$D$12","v":0}]
[null,null,{"$f":"PASO_1!C51","v":0},{"$f":"PASO_1!D51","v":0},{"$f":"PASO_1!E51","v":0},{"$f":"PASO_1!F51","v":0},{"$f":"PASO_1!G51","v":0},{"$f":"PASO_1!H51","v":0},{"$f":"PASO_1!I51","v":0},{"$f":"PASO_1!J51","v":0},{"$f":"PASO_1!K51","v":0},{"$f":"PASO_1!L51","v":0},{"$f":"PASO_1!M51","v":0},{"$f":"PASO_1!N51","v":0},{"$f":"PASO_1!O51","v":0},"x",null,null,null,null,null,{"$f":"$E$12","v":0},{"$f":"$E$16","v":0},{"$f":"$E$15","v":0},null,{"$f":"$E$17","v":0},{"$f":"$E$12","v":0}]
[null,null,{"$f":"PASO_1!C52","v":0},{"$f":"PASO_1!D52","v":0},{"$f":"PASO_1!E52","v":0},{"$f":"PASO_1!F52","v":0},{"$f":"PASO_1!G52","v":0},{"$f":"PASO_1!H52","v":0},{"$f":"PASO_1!I52","v":0},{"$f":"PASO_1!J52","v":0},{"$f":"PASO_1!K52","v":0},{"$f":"PASO_1!L52","v":0},{"$f":"PASO_1!M52","v":0},{"$f":"PASO_1!N52","v":0},{"$f":"PASO_1!O52","v":0},{"$f":"Q30","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"$F$12","v":0},{"$f":"$F$16","v":0},{"$f":"$F$15","v":0},null,{"$f":"$F$17","v":0},{"$f":"$F$12","v":0}]
["Capturar","Poner un 1 en la línea base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$12","v":0},{"$f":"$G$16","v":0},{"$f":"$G$15","v":0},null,{"$f":"$G$17","v":0},{"$f":"$G$12","v":0}]
["Capturar","Poner un 1 debajo de la meta deseada",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,{"$f":"$H$12","v":0},{"$f":"$H$16","v":0},{"$f":"$H$15","v":0},null,{"$f":"$H$17","v":0},{"$f":"$H$12","v":0}]
["Capturar","Poner un 0 donde se seleccionó la LB, y capturar el valor consecutivo hacia atrás y hacia adelante debajo de los años donde haya valores",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$I$12","v":0},{"$f":"$I$16","v":0},{"$f":"$I$15","v":0},null,{"$f":"$I$17","v":0},{"$f":"$I$12","v":0}]
["Capturar","Poner un \"1\" debajo de la LB, y poner un uno en las casillas subsecuentes hasta llegar al año de la meta deseada (también poner 1 debajo de la meta desada)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$J$12","v":0},{"$f":"$J$16","v":0},{"$f":"$J$15","v":0},null,{"$f":"$J$17","v":0},{"$f":"$J$12","v":0}]
[null,"Cálculos del numerador",{"$f":"C15*C18","v":0},0,0,{"$f":"F15*F18","v":0},{"$f":"G15*G18","v":0},{"$f":"H15*H18","v":0},0,0,0,0,0,0,0,{"$error":"#N/A"},null,null,null,null,null,{"$f":"$K$12","v":0},{"$f":"$K$16","v":0},{"$f":"$K$15","v":0},null,{"$f":"$K$17","v":0},{"$f":"$K$12","v":0}]
[null,"Cálculos del denominador",{"$f":"C18^2","v":0},0,0,{"$f":"F18^2","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"$L$12","v":0},{"$f":"$L$16","v":0},{"$f":"$L$15","v":0},null,{"$f":"$L$17","v":0},{"$f":"$L$12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$M$12","v":0},{"$f":"$M$16","v":0},{"$f":"$M$15","v":0},null,{"$f":"$M$17","v":0},{"$f":"$M$12","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(C20:O20)","v":0},null,null,{"$f":"SUM(C19:P19)","v":0},null,null,{"$f":"G23","v":0},null,{"$f":"J23","v":0},null,{"$f":"((M23/M26)*(O23/O26))","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"$N$12","v":0},{"$f":"$N$16","v":0},{"$f":"$N$15","v":0},null,{"$f":"$N$17","v":0},{"$f":"$N$12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"*",null,"=",null,null,null,null,null,{"$f":"$O$12","v":0},{"$f":"$O$16","v":0},{"$f":"$O$15","v":0},null,{"$f":"$O$17","v":0},{"$f":"$O$12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$12","v":2024},{"$f":"$P$16","v":0},{"$f":"$P$15","v":{"$error":"#N/A"}},null,{"$f":"$P$17","v":1},{"$f":"$P$12","v":2024}]
[null,null,null,null,null,null,{"$f":"SUM(C21:O21)","v":0},null,null,2,null,null,{"$f":"G26","v":0},null,{"$f":"J26","v":2}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meta estimada"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(1,$W$12:$X$25,2,0)","v":{"$error":"#N/A"}},null,null,{"$f":"$Q$23","v":{"$error":"#DIV/0!"}},null,null,{"$f":"$G$30","v":{"$error":"#N/A"}},null,{"$f":"$J$30","v":{"$error":"#DIV/0!"}},null,{"$f":"M30+O30","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"="]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(1,$Z$12:$AA$25,2,0)","v":2024}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(D39, L32)","v":"𝑦 ̂2024"}]
[]
[]
[]
[]
[null,null,null,"∆","Cambio estimado del periodo de referencia",null,null,null,"𝑦𝑏𝑎𝑠𝑒","Valor del indicador en el año base"]
[null,null,null,"𝑦 ̂","Valor del indicador esimado como meta",null,null,null,"z","Valor de tiempo según año base"]
[null,null,null,"𝑦","Valor del indicador",null,null,null,"n","Número de años desde el año base hasta el año a estimar"]

{"sheet":"Incr.","index":2,"n_rows":44,"n_cols":24,"rows_kept":44,"cut":false,"hidden":false,"merged":[[27,15,31,16],[28,12,30,12],[28,14,30,14],[30,6,31,6],[33,13,33,14],[27,13,31,13],[34,4,38,6],[34,8,38,8],[34,9,38,9],[34,11,38,11],[34,13,38,14],[35,10,37,10],[35,12,37,12],[27,2,31,4],[27,6,28,6],[27,7,31,7],[27,9,31,10],[27,11,31,11],[17,19,18,19],[20,2,24,3],[20,5,24,5],[20,6,21,6],[20,8,24,8],[21,7,23,7],[23,6,24,6],[7,2,7,15],[8,2,8,15],[9,2,9,15],[1,1,1,15],[2,1,2,15],[4,2,4,15],[5,2,5,15],[6,2,6,15]]}
[]
[null,"Plantilla para cálculo de metas"]
[null,"Método Incremental"]
[]
[null,"Nombre del indicador:",{"$f":"PASO_1!$E$9","v":0}]
[null,"Nombre variable numerador:",{"$f":"PASO_1!$E$10","v":0}]
[null,"Nombre variable denominador:",{"$f":"PASO_1!$E$11","v":0}]
[null,"Método de cálculo",{"$f":"PASO_1!$E$12","v":0}]
[null,"Programa donde se le da seguimiento:",{"$f":"PASO_1!$E$13","v":0}]
[null,"Nivel del objetivo:",{"$f":"PASO_1!$E$14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"META",null,null,null,null,null,null,"Meta","Año"]
[null,null,{"$f":"PASO_1!C49","v":0},{"$f":"PASO_1!D49","v":0},{"$f":"PASO_1!E49","v":0},{"$f":"PASO_1!F49","v":0},{"$f":"PASO_1!G49","v":0},{"$f":"PASO_1!H49","v":0},{"$f":"PASO_1!I49","v":0},{"$f":"PASO_1!J49","v":0},{"$f":"PASO_1!K49","v":0},{"$f":"PASO_1!L49","v":0},{"$f":"PASO_1!M49","v":0},{"$f":"PASO_1!N49","v":0},{"$f":"PASO_1!O49","v":0},{"$f":"PASO_1!P49","v":2024},null,null,null,null,null,null,{"$f":"$C$17","v":0},{"$f":"$C$12","v":0}]
[null,null,{"$f":"PASO_1!C50","v":0},{"$f":"PASO_1!D50","v":0},{"$f":"PASO_1!E50","v":0},{"$f":"PASO_1!F50","v":0},{"$f":"PASO_1!G50","v":0},{"$f":"PASO_1!H50","v":0},{"$f":"PASO_1!I50","v":0},{"$f":"PASO_1!J50","v":0},{"$f":"PASO_1!K50","v":0},{"$f":"PASO_1!L50","v":0},{"$f":"PASO_1!M50","v":0},{"$f":"PASO_1!N50","v":0},{"$f":"PASO_1!O50","v":0},"x",null,null,null,null,null,null,{"$f":"$D$17","v":0},{"$f":"$D$12","v":0}]
[null,null,{"$f":"PASO_1!C51","v":0},{"$f":"PASO_1!D51","v":0},{"$f":"PASO_1!E51","v":0},{"$f":"PASO_1!F51","v":0},{"$f":"PASO_1!G51","v":0},{"$f":"PASO_1!H51","v":0},{"$f":"PASO_1!I51","v":0},{"$f":"PASO_1!J51","v":0},{"$f":"PASO_1!K51","v":0},{"$f":"PASO_1!L51","v":0},{"$f":"PASO_1!M51","v":0},{"$f":"PASO_1!N51","v":0},{"$f":"PASO_1!O51","v":0},"x",null,null,null,null,null,null,{"$f":"$E$17","v":0},{"$f":"$E$12","v":0}]
[null,null,{"$f":"PASO_1!C52","v":0},{"$f":"PASO_1!D52","v":0},{"$f":"PASO_1!E52","v":0},{"$f":"PASO_1!F52","v":0},{"$f":"PASO_1!G52","v":0},{"$f":"PASO_1!H52","v":0},{"$f":"PASO_1!I52","v":0},{"$f":"PASO_1!J52","v":0},{"$f":"PASO_1!K52","v":0},{"$f":"PASO_1!L52","v":0},{"$f":"PASO_1!M52","v":0},{"$f":"PASO_1!N52","v":0},{"$f":"PASO_1!O52","v":0},{"$f":"N35","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"$F$17","v":0},{"$f":"$F$12","v":0}]
["Capturar","Poner un 1 en la línea base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$17","v":0},{"$f":"$G$12","v":0}]
["Capturar","Poner un 1 debajo de la meta deseada",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"$H$17","v":0},{"$f":"$H$12","v":0}]
[null,null,{"$f":"IF(C15, ((D15/C15)-1), \" \")","v":" "},{"$f":"IF(D15, ((E15/D15)-1), \" \")","v":" "},{"$f":"IF(E15, ((F15/E15)-1), \" \")","v":" "},{"$f":"IF(F15, ((G15/F15)-1), \" \")","v":" "}," "," "," "," "," "," "," "," ","X","X",null,null,null,null,null,null,{"$f":"$I$17","v":0},{"$f":"$I$12","v":0}]
[null,"T",{"$f":"COUNT(C18)","v":0},{"$f":"COUNT(D18)","v":0},{"$f":"COUNT(E18)","v":0},0,0,0,0,0,0,0,0,0,"X","X",null,null,null,null,null,null,{"$f":"$J$17","v":0},{"$f":"$J$12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$K$17","v":0},{"$f":"$K$12","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(C18:N18)","v":0},null,{"$f":"G21/G24","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$L$17","v":0},{"$f":"$L$12","v":0}]
[null,null,null,null,null,null,null,"=",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$M$17","v":0},{"$f":"$M$12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$N$17","v":0},{"$f":"$N$12","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(C19:N19)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$17","v":0},{"$f":"$O$12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$17","v":1},{"$f":"$P$12","v":2024}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"LOOKUP(MAX(C15:O15)+1, C15:O15, C15:O15)","v":0},null,null,null,{"$f":"$I$21","v":{"$error":"#DIV/0!"}},null,1,null,{"$f":"L28+N28","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"="]
[null,null,null,null,null,null,{"$f":"VLOOKUP(1,$W$12:$X$25,2,0)-1","v":2023}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(D44, G30)","v":"𝑦 ̂2023"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Meta deseada"]
[null,null,null,null,null,null,null,null,null,{"$f":"H28","v":0},null,{"$f":"P28","v":{"$error":"#DIV/0!"}},null,{"$f":"J35*L35","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"*",null,"="]
[]
[]
[]
[]
[]
[null,null,null,"∆","Tasa de variación de las observaciones",null,null,null,"y1, y0","Observaciones del indicador en diferentes periodos de tiempo"]
[null,null,null,"Δ ̅","Promedio de tasa de variación",null,null,null,"T","Número total de tasas de variaciones (número de periodos de los que se tiene información menos 1)"]
[null,null,null,"𝑦 ̂","Valor estimado como meta",null,null,null,"Yt-1","Valor del periodo inmediato anterior al que se estimará como meta"]

{"sheet":"Lineal","index":3,"n_rows":51,"n_cols":24,"rows_kept":51,"cut":false,"hidden":false,"merged":[[41,13,45,13],[42,7,44,7],[42,9,44,9],[34,13,38,13],[35,7,37,7],[35,9,37,9],[40,12,40,13],[41,12,45,12],[34,12,38,12],[41,2,45,3],[41,5,45,5],[41,6,45,6],[41,8,45,8],[41,10,45,10],[34,2,38,3],[34,5,38,5],[34,6,38,6],[34,8,38,8],[34,10,38,10],[31,12,32,14],[28,12,29,12],[28,13,29,13],[28,14,29,14],[28,16,32,16],[29,15,31,15],[28,11,29,11],[31,7,32,8],[31,9,32,9],[31,10,32,10],[31,11,32,11],[28,2,32,4],[28,6,32,6],[28,7,29,8],[28,9,29,9],[28,10,29,10],[17,19,18,19],[22,2,26,3],[22,5,26,6],[22,8,26,8],[22,9,23,9],[22,11,26,11],[22,13,26,13],[22,14,23,14],[22,16,26,16],[23,10,25,10],[23,15,25,15],[25,9,26,9],[25,14,26,14],[7,2,7,15],[8,2,8,15],[9,2,9,15],[1,1,1,15],[2,1,2,15],[4,2,4,15],[5,2,5,15],[6,2,6,15]]}
[]
[null,"Plantilla para cálculo de metas"]
[null,"Extrapolación Lineal"]
[]
[null,"Nombre del indicador:",{"$f":"PASO_1!$E$9","v":0}]
[null,"Nombre variable numerador:",{"$f":"PASO_1!$E$10","v":0}]
[null,"Nombre variable denominador:",{"$f":"PASO_1!$E$11","v":0}]
[null,"Método de cálculo",{"$f":"PASO_1!$E$12","v":0}]
[null,"Programa donde se le da seguimiento:",{"$f":"PASO_1!$E$13","v":0}]
[null,"Nivel del objetivo:",{"$f":"PASO_1!$E$14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"META",null,null,null,null,null,null,"Meta","Año"]
[null,null,{"$f":"PASO_1!C49","v":0},{"$f":"PASO_1!D49","v":0},{"$f":"PASO_1!E49","v":0},{"$f":"PASO_1!F49","v":0},{"$f":"PASO_1!G49","v":0},{"$f":"PASO_1!H49","v":0},{"$f":"PASO_1!I49","v":0},{"$f":"PASO_1!J49","v":0},{"$f":"PASO_1!K49","v":0},{"$f":"PASO_1!L49","v":0},{"$f":"PASO_1!M49","v":0},{"$f":"PASO_1!N49","v":0},{"$f":"PASO_1!O49","v":0},{"$f":"PASO_1!P49","v":2024},null,null,null,null,null,null,{"$f":"$C$17","v":0},{"$f":"$C$12","v":0}]
[null,null,{"$f":"PASO_1!C50","v":0},{"$f":"PASO_1!D50","v":0},{"$f":"PASO_1!E50","v":0},{"$f":"PASO_1!F50","v":0},{"$f":"PASO_1!G50","v":0},{"$f":"PASO_1!H50","v":0},{"$f":"PASO_1!I50","v":0},{"$f":"PASO_1!J50","v":0},{"$f":"PASO_1!K50","v":0},{"$f":"PASO_1!L50","v":0},{"$f":"PASO_1!M50","v":0},{"$f":"PASO_1!N50","v":0},{"$f":"PASO_1!O50","v":0},"x",null,null,null,null,null,null,{"$f":"$D$17","v":0},{"$f":"$D$12","v":0}]
[null,null,{"$f":"PASO_1!C51","v":0},{"$f":"PASO_1!D51","v":0},{"$f":"PASO_1!E51","v":0},{"$f":"PASO_1!F51","v":0},{"$f":"PASO_1!G51","v":0},{"$f":"PASO_1!H51","v":0},{"$f":"PASO_1!I51","v":0},{"$f":"PASO_1!J51","v":0},{"$f":"PASO_1!K51","v":0},{"$f":"PASO_1!L51","v":0},{"$f":"PASO_1!M51","v":0},{"$f":"PASO_1!N51","v":0},{"$f":"PASO_1!O51","v":0},"x",null,null,null,null,null,null,{"$f":"$E$17","v":0},{"$f":"$E$12","v":0}]
[null,null,{"$f":"PASO_1!C52","v":0},{"$f":"PASO_1!D52","v":0},{"$f":"PASO_1!E52","v":0},{"$f":"PASO_1!F52","v":0},{"$f":"PASO_1!G52","v":0},{"$f":"PASO_1!H52","v":0},{"$f":"PASO_1!I52","v":0},{"$f":"PASO_1!J52","v":0},{"$f":"PASO_1!K52","v":0},{"$f":"PASO_1!L52","v":0},{"$f":"PASO_1!M52","v":0},{"$f":"PASO_1!N52","v":0},{"$f":"PASO_1!O52","v":0},{"$f":"N42","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"$F$17","v":0},{"$f":"$F$12","v":0}]
["Capturar","Poner un 1 en la línea base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$17","v":0},{"$f":"$G$12","v":0}]
["Capturar","Poner un 1 debajo de la meta deseada",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"$H$17","v":0},{"$f":"$H$12","v":0}]
[null,null,{"$f":"IF(C15, (C12*C15), \" \")","v":" "},{"$f":"IF(D15, (D12*D15), \" \")","v":" "}," ",{"$f":"IF(F15, (F12*F15), \" \")","v":" "}," "," "," "," "," "," "," "," "," ",null,null,null,null,null,null,null,{"$f":"$I$17","v":0},{"$f":"$I$12","v":0}]
[null,"n",{"$f":"COUNT(C18)","v":0},{"$f":"COUNT(D18)","v":0},0,0,0,0,0,{"$f":"COUNT(J18)","v":0},{"$f":"COUNT(K18)","v":0},{"$f":"COUNT(L18)","v":0},{"$f":"COUNT(M18)","v":0},{"$f":"COUNT(N18)","v":0},{"$f":"COUNT(O18)","v":0},null,null,null,null,null,null,null,{"$f":"$J$17","v":0},{"$f":"$J$12","v":0}]
[null,"Años con datos",{"$f":"C12*C19","v":0},{"$f":"D12*D19","v":0},0,{"$f":"F12*F19","v":0},0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C20^2","v":0},{"$f":"D20^2","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$K$17","v":0},{"$f":"$K$12","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(C15:O15)","v":0},null,{"$f":"J23/J26","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(C20:O20)","v":0},null,{"$f":"O23/O26","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"$L$17","v":0},{"$f":"$L$12","v":0}]
[null,null,null,null,null,null,null,null,null,null,"=",null,null,null,null,"=",null,null,null,null,null,null,{"$f":"$M$17","v":0},{"$f":"$M$12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$N$17","v":0},{"$f":"$N$12","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(C19:O19)","v":0},null,null,null,null,{"$f":"SUM(C19:O19)","v":0},null,null,null,null,null,null,null,{"$f":"$O$17","v":0},{"$f":"$O$12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$17","v":1},{"$f":"$P$12","v":2024}]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(C18:O18)","v":0},null,"-",{"$f":"SUM(C19:O19)","v":0},"*",{"$f":"Q23","v":{"$error":"#DIV/0!"}},"*",{"$f":"L23","v":{"$error":"#DIV/0!"}},null,{"$f":"((H29-(K29*M29*O29))/(H32-(K32*M32)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"="]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(C21:O21)","v":0},null,"-",{"$f":"K29","v":0},"*",{"$f":"Q23^2","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,null,{"$f":"L23","v":{"$error":"#DIV/0!"}},null,{"$f":"Q29","v":{"$error":"#DIV/0!"}},null,{"$f":"Q23","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(G35-(I35*K35))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"-",null,"*"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Meta deseada"]
[null,null,null,null,null,null,{"$f":"N35","v":{"$error":"#DIV/0!"}},null,{"$f":"Q29","v":{"$error":"#DIV/0!"}},null,{"$f":"VLOOKUP(1,$W$12:$X$27,2,0)","v":2024},null,null,{"$f":"(G42+(I42*K42))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"+",null,"*"]
[]
[]
[]
[]
[null,null,null,"𝑦 ̂","Es el valor estimado de la meta.",null,null,null,"y","Es el valor de las observaciones del indicador"]
[null,null,null,"a","Es el valor del origen de la recta.",null,null,null,"𝑥 ̅","Es el promedio de la variable x."]
[null,null,null,"b","Es el valor de la pendiente de la recta.",null,null,null,"𝑦 ̅","Es el promedio de la variable y."]
[null,null,null,"x","Es el valor que corresponde al periodo.",null,null,null,"n","Es el número de observaciones."]

{"sheet":"Tend_FORMULA","index":4,"n_rows":40,"n_cols":27,"rows_kept":40,"cut":false,"hidden":true,"merged":[[30,13,32,13],[30,15,32,15],[32,11,33,11],[28,16,28,17],[29,2,33,3],[29,5,33,5],[29,6,33,6],[29,8,33,8],[29,9,33,9],[29,11,30,11],[29,12,33,12],[29,14,33,14],[29,16,33,17],[10,17,10,18],[14,17,14,18],[12,17,12,18],[13,17,13,18],[11,17,11,18],[17,19,18,19],[22,2,26,3],[22,5,26,5],[22,6,23,6],[22,8,26,8],[22,9,23,9],[22,11,26,11],[22,12,23,12],[22,14,23,14],[22,16,26,17],[23,13,25,13],[23,15,25,15],[25,6,26,6],[25,9,26,9],[25,12,26,12],[25,14,26,14],[1,1,1,15],[12,1,13,1],[4,2,4,15],[5,2,5,15],[6,2,6,15],[8,2,8,15],[9,2,9,15],[7,2,7,15],[2,1,2,15]]}
[]
[null,"Plantilla para cálculo de metas"]
[null,"Método de tendencias"]
[]
[null,"Nombre del indicador:"]
[null,"Nombre variable numerador:"]
[null,"Nombre variable denominador:"]
[null,"Método de cálculo"]
[null,"Programa donde se le da seguimiento:"]
[null,"Nivel del objetivo:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meta estimada",null,null,null,"Año","LB","Valor",null,"Meta","Año"]
["Capturar","Capturar años de los cuales se tienen valores","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019","2020","2021","2022","2023",null,{"$f":"L32","v":{"$error":"#N/A"}},null,null,null,{"$f":"$C$12","v":"2010"},{"$f":"$C$16","v":0},{"$f":"$C$15","v":0},null,{"$f":"$C$17","v":0},{"$f":"$C$12","v":"2010"}]
["Capturar","Capturar valores históricos del numerador y denominador. O si desea encontrar la meta estimada de un valor absoluto, deje en blanco estas casillas y sólo capture los valores en la siguiente fila.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$12","v":"2011"},{"$f":"$D$16","v":0},{"$f":"$D$15","v":0},null,{"$f":"$D$17","v":0},{"$f":"$D$12","v":"2011"}]
["Capturar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$12","v":"2012"},{"$f":"$E$16","v":0},{"$f":"$E$15","v":0},null,{"$f":"$E$17","v":0},{"$f":"$E$12","v":"2012"}]
["Capturar","Capturar valores históricos o aplicar fórmula",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q30","v":{"$error":"#N/A"}},null,null,null,{"$f":"$F$12","v":"2013"},{"$f":"$F$16","v":0},{"$f":"$F$15","v":0},null,{"$f":"$F$17","v":0},{"$f":"$F$12","v":"2013"}]
["Capturar","Poner un 1 en la línea base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$12","v":"2014"},{"$f":"$G$16","v":0},{"$f":"$G$15","v":0},null,{"$f":"$G$17","v":0},{"$f":"$G$12","v":"2014"}]
["Capturar","Poner un 1 debajo de la meta deseada",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$H$12","v":"2015"},{"$f":"$H$16","v":0},{"$f":"$H$15","v":0},null,{"$f":"$H$17","v":0},{"$f":"$H$12","v":"2015"}]
["Capturar","Poner un 0 donde se seleccionó la LB, y capturar el valor consecutivo hacia atrás y hacia adelante debajo de los años donde haya valores",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$I$12","v":"2016"},{"$f":"$I$16","v":0},{"$f":"$I$15","v":0},null,{"$f":"$I$17","v":0},{"$f":"$I$12","v":"2016"}]
["Capturar","Poner un \"1\" debajo de la LB, y poner un uno en las casillas subsecuentes hasta llegar al año de la meta deseada (también poner 1 debajo de la meta desada)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$J$12","v":"2017"},{"$f":"$J$16","v":0},{"$f":"$J$15","v":0},null,{"$f":"$J$17","v":0},{"$f":"$J$12","v":"2017"}]
[null,"Cálculos del numerador",{"$f":"C15*C18","v":0},0,0,{"$f":"F15*F18","v":0},{"$f":"G15*G18","v":0},{"$f":"H15*H18","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"$K$12","v":"2018"},{"$f":"$K$16","v":0},{"$f":"$K$15","v":0},null,{"$f":"$K$17","v":0},{"$f":"$K$12","v":"2018"}]
[null,"Cálculos del denominador",{"$f":"C18^2","v":0},0,0,{"$f":"F18^2","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"$L$12","v":"2019"},{"$f":"$L$16","v":0},{"$f":"$L$15","v":0},null,{"$f":"$L$17","v":0},{"$f":"$L$12","v":"2019"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$M$12","v":"2020"},{"$f":"$M$16","v":0},{"$f":"$M$15","v":0},null,{"$f":"$M$17","v":0},{"$f":"$M$12","v":"2020"}]
[null,null,null,null,null,null,{"$f":"SUM(C20:P20)","v":0},null,null,{"$f":"SUM(C19:P19)","v":0},null,null,{"$f":"G23","v":0},null,{"$f":"J23","v":0},null,{"$f":"((M23/M26)*(O23/O26))","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"$N$12","v":"2021"},{"$f":"$N$16","v":0},{"$f":"$N$15","v":0},null,{"$f":"$N$17","v":0},{"$f":"$N$12","v":"2021"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"*",null,"=",null,null,null,null,null,{"$f":"$O$12","v":"2022"},{"$f":"$O$16","v":0},{"$f":"$O$15","v":0},null,{"$f":"$O$17","v":0},{"$f":"$O$12","v":"2022"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$12","v":"2023"},{"$f":"$P$16","v":0},{"$f":"$P$15","v":0},null,{"$f":"$P$17","v":0},{"$f":"$P$12","v":"2023"}]
[null,null,null,null,null,null,{"$f":"SUM(C21:P21)","v":0},null,null,2,null,null,{"$f":"G26","v":0},null,{"$f":"J26","v":2}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meta estimada"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(1,$W$12:$X$25,2,0)","v":{"$error":"#N/A"}},null,null,{"$f":"$Q$23","v":{"$error":"#DIV/0!"}},null,null,{"$f":"$G$30","v":{"$error":"#N/A"}},null,{"$f":"$J$30","v":{"$error":"#DIV/0!"}},null,{"$f":"M30+O30","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"="]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(1,$Z$12:$AA$25,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(D39, L32)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[null,null,null,"∆","Cambio estimado del periodo de referencia",null,null,null,"𝑦𝑏𝑎𝑠𝑒","Valor del indicador en el año base"]
[null,null,null,"𝑦 ̂","Valor del indicador esimado como meta",null,null,null,"z","Valor de tiempo según año base"]
[null,null,null,"𝑦","Valor del indicador",null,null,null,"n","Número de años desde el año base hasta el año a estimar"]

{"sheet":"Incr_FORMULA","index":5,"n_rows":44,"n_cols":24,"rows_kept":44,"cut":false,"hidden":true,"merged":[[27,15,31,16],[28,12,30,12],[28,14,30,14],[14,17,14,18],[30,6,31,6],[27,13,31,13],[33,13,33,14],[34,4,38,6],[34,8,38,8],[34,9,38,9],[34,11,38,11],[34,13,38,14],[35,10,37,10],[35,12,37,12],[27,2,31,4],[27,6,28,6],[27,7,31,7],[27,9,31,10],[27,11,31,11],[17,19,18,19],[20,2,24,3],[20,5,24,5],[20,6,21,6],[20,8,24,8],[21,7,23,7],[23,6,24,6],[1,1,1,15],[10,17,10,18],[11,17,11,18],[12,17,12,18],[13,17,13,18],[7,2,7,15],[2,1,2,15],[4,2,4,15],[5,2,5,15],[6,2,6,15],[8,2,8,15],[9,2,9,15]]}
[]
[null,"Plantilla para cálculo de metas"]
[null,"Método Incremental"]
[]
[null,"Nombre del indicador:"]
[null,"Nombre variable numerador:"]
[null,"Nombre variable denominador:"]
[null,"Método de cálculo"]
[null,"Programa donde se le da seguimiento:"]
[null,"Nivel del objetivo:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meta estimada",null,null,null,null,"Meta","Año"]
["Capturar","Capturar años de los cuales se tienen valores","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019","2020","2021","2022","2023",null,{"$f":"G30+1","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"$C$17","v":0},{"$f":"$C$12","v":"2010"}]
["Capturar","Capturar valores históricos del numerador",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$17","v":0},{"$f":"$D$12","v":"2011"}]
["Capturar","Capturar históricos del denominador",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$17","v":0},{"$f":"$E$12","v":"2012"}]
["Capturar","Capturar valores históricos o aplicar fórmula",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N35","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"$F$17","v":0},{"$f":"$F$12","v":"2013"}]
["Capturar","Poner un 1 en la línea base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$17","v":0},{"$f":"$G$12","v":"2014"}]
["Capturar","Poner un 1 debajo de la meta deseada",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$H$17","v":0},{"$f":"$H$12","v":"2015"}]
[null,null,{"$f":"IF(C15, ((D15/C15)-1), \" \")","v":" "},{"$f":"IF(D15, ((E15/D15)-1), \" \")","v":" "},{"$f":"IF(E15, ((F15/E15)-1), \" \")","v":" "},{"$f":"IF(F15, ((G15/F15)-1), \" \")","v":" "}," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,null,{"$f":"$I$17","v":0},{"$f":"$I$12","v":"2016"}]
[null,"T",{"$f":"COUNT(C18)","v":0},{"$f":"COUNT(D18)","v":0},{"$f":"COUNT(E18)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,{"$f":"$J$17","v":0},{"$f":"$J$12","v":"2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$K$17","v":0},{"$f":"$K$12","v":"2018"}]
[null,null,null,null,null,null,{"$f":"SUM(C18:P18)+1","v":1},null,{"$f":"G21/G24","v":-1},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$L$17","v":0},{"$f":"$L$12","v":"2019"}]
[null,null,null,null,null,null,null,"=",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$M$17","v":0},{"$f":"$M$12","v":"2020"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$N$17","v":0},{"$f":"$N$12","v":"2021"}]
[null,null,null,null,null,null,{"$f":"SUM(C19:P19)-1","v":-1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$17","v":0},{"$f":"$O$12","v":"2022"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$17","v":0},{"$f":"$P$12","v":"2023"}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"LOOKUP(MAX(C15:P15)+1, C15:P15, C15:P15)","v":{"$error":"#N/A"}},null,null,null,{"$f":"$I$21","v":-1},null,1,null,{"$f":"L28+N28","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"="]
[null,null,null,null,null,null,{"$f":"VLOOKUP(1,$W$12:$X$25,2,0)-1","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(D44, G30)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Meta deseada"]
[null,null,null,null,null,null,null,null,null,{"$f":"H28","v":{"$error":"#N/A"}},null,{"$f":"P28","v":0},null,{"$f":"J35*L35","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,"*",null,"="]
[]
[]
[]
[]
[]
[null,null,null,"∆","Tasa de variación de las observaciones",null,null,null,"y1, y0","Observaciones del indicador en diferentes periodos de tiempo"]
[null,null,null,"Δ ̅","Promedio de tasa de variación",null,null,null,"T","Número total de tasas de variaciones (número de periodos de los que se tiene información menos 1)"]
[null,null,null,"𝑦 ̂","Valor estimado como meta",null,null,null,"Yt-1","Valor del periodo inmediato anterior al que se estimará como meta"]

{"sheet":"Lineal_FORMULA","index":6,"n_rows":51,"n_cols":24,"rows_kept":51,"cut":false,"hidden":true,"merged":[[41,13,45,13],[42,7,44,7],[42,9,44,9],[34,13,38,13],[35,7,37,7],[35,9,37,9],[40,12,40,13],[41,12,45,12],[34,12,38,12],[41,2,45,3],[41,5,45,5],[41,6,45,6],[41,8,45,8],[41,10,45,10],[34,2,38,3],[34,5,38,5],[34,6,38,6],[34,8,38,8],[34,10,38,10],[31,12,32,14],[28,12,29,12],[28,13,29,13],[28,14,29,14],[28,16,32,16],[29,15,31,15],[28,11,29,11],[31,7,32,8],[31,9,32,9],[31,10,32,10],[31,11,32,11],[28,2,32,4],[28,6,32,6],[28,7,29,8],[28,9,29,9],[28,10,29,10],[14,17,14,18],[23,10,25,10],[23,15,25,15],[25,9,26,9],[25,14,26,14],[17,19,18,19],[22,2,26,3],[22,5,26,6],[22,8,26,8],[22,9,23,9],[22,11,26,11],[22,13,26,13],[22,14,23,14],[22,16,26,16],[1,1,1,15],[10,17,10,18],[11,17,11,18],[12,17,12,18],[13,17,13,18],[7,2,7,15],[2,1,2,15],[4,2,4,15],[5,2,5,15],[6,2,6,15],[8,2,8,15],[9,2,9,15]]}
[]
[null,"Plantilla para cálculo de metas"]
[null,"Extrapolación Lineal"]
[]
[null,"Nombre del indicador:"]
[null,"Nombre variable numerador:"]
[null,"Nombre variable denominador:"]
[null,"Método de cálculo"]
[null,"Programa donde se le da seguimiento:"]
[null,"Nivel del objetivo:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meta estimada",null,null,null,null,"Meta","Año"]
["Capturar","Capturar años de los cuales se tienen valores",2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,null,{"$f":"VLOOKUP(1,$W$12:$X$27,2,0)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"$C$17","v":0},{"$f":"$C$12","v":2010}]
["Capturar","Capturar valores históricos del numerador",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$17","v":0},{"$f":"$D$12","v":2011}]
["Capturar","Capturar históricos del denominador",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$17","v":0},{"$f":"$E$12","v":2012}]
["Capturar","Capturar valores históricos o aplicar fórmula",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N42","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"$F$17","v":0},{"$f":"$F$12","v":2013}]
["Capturar","Poner un 1 en la línea base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$17","v":0},{"$f":"$G$12","v":2014}]
["Capturar","Poner un 1 debajo de la meta deseada",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$H$17","v":0},{"$f":"$H$12","v":2015}]
[null,null,{"$f":"IF(C15, (C12*C15), \" \")","v":" "},{"$f":"IF(D15, (D12*D15), \" \")","v":" "}," ",{"$f":"IF(F15, (F12*F15), \" \")","v":" "}," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,null,{"$f":"$I$17","v":0},{"$f":"$I$12","v":2016}]
[null,"n",{"$f":"COUNT(C15)","v":0},0,0,{"$f":"COUNT(F15)","v":0},{"$f":"COUNT(G15)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,{"$f":"$J$17","v":0},{"$f":"$J$12","v":2017}]
[null,"Años con datos",{"$f":"C12*C19","v":0},{"$f":"D12*D19","v":0},0,{"$f":"F12*F19","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C20^2","v":0},{"$f":"D20^2","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$K$17","v":0},{"$f":"$K$12","v":2018}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(C15:P15)","v":0},null,{"$f":"J23/J26","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(C20:P20)","v":0},null,{"$f":"O23/O26","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"$L$17","v":0},{"$f":"$L$12","v":2019}]
[null,null,null,null,null,null,null,null,null,null,"=",null,null,null,null,"=",null,null,null,null,null,null,{"$f":"$M$17","v":0},{"$f":"$M$12","v":2020}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$N$17","v":0},{"$f":"$N$12","v":2021}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(C19:P19)","v":0},null,null,null,null,{"$f":"SUM(C19:P19)","v":0},null,null,null,null,null,null,null,{"$f":"$O$17","v":0},{"$f":"$O$12","v":2022}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$17","v":0},{"$f":"$P$12","v":2023}]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(C18:P18)","v":0},null,"-",{"$f":"SUM(C19:P19)","v":0},"*",{"$f":"Q23","v":{"$error":"#DIV/0!"}},"*",{"$f":"L23","v":{"$error":"#DIV/0!"}},null,{"$f":"((H29-(K29*M29*O29))/(H32-(K32*M32)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"="]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(C21:P21)","v":0},null,"-",{"$f":"K29","v":0},"*",{"$f":"Q23^2","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,null,{"$f":"L23","v":{"$error":"#DIV/0!"}},null,{"$f":"Q29","v":{"$error":"#DIV/0!"}},null,{"$f":"Q23","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(G35-(I35*K35))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"-",null,"*"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Meta deseada"]
[null,null,null,null,null,null,{"$f":"N35","v":{"$error":"#DIV/0!"}},null,{"$f":"Q29","v":{"$error":"#DIV/0!"}},null,{"$f":"VLOOKUP(1,$W$12:$X$27,2,0)","v":{"$error":"#N/A"}},null,null,{"$f":"(G42+(I42*K42))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"+",null,"*"]
[]
[]
[]
[]
[null,null,null,"𝑦 ̂","Es el valor estimado de la meta.",null,null,null,"y","Es el valor de las observaciones del indicador"]
[null,null,null,"a","Es el valor del origen de la recta.",null,null,null,"𝑥 ̅","Es el promedio de la variable x."]
[null,null,null,"b","Es el valor de la pendiente de la recta.",null,null,null,"𝑦 ̅","Es el promedio de la variable y."]
[null,null,null,"x","Es el valor que corresponde al periodo.",null,null,null,"n","Es el número de observaciones."]

{"sheet":"PASO_3","index":7,"n_rows":63,"n_cols":19,"rows_kept":63,"cut":false,"hidden":false,"merged":[[12,6,12,18],[13,6,13,18],[13,1,13,5],[23,16,25,16],[23,17,25,17],[17,15,18,15],[22,13,22,17],[19,6,20,18],[25,13,25,15],[23,13,23,15],[24,13,24,15],[23,10,23,11],[24,10,24,11],[25,10,25,11],[22,6,22,10],[24,6,24,9],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[8,6,8,18],[4,1,4,18],[6,1,6,18],[15,1,15,18],[17,8,18,10],[17,12,18,14],[17,16,18,17],[9,6,9,18],[10,6,10,18],[11,6,11,18],[17,18,18,18],[17,11,18,11],[17,1,18,1],[17,2,18,5],[17,6,18,6],[17,7,18,7],[62,1,64,15],[30,15,31,15],[30,16,31,16],[19,1,20,1],[19,2,20,5],[23,1,23,2],[24,1,24,2],[25,1,25,2],[23,4,25,4],[30,3,30,13],[28,1,28,18],[27,1,27,18],[23,6,23,9],[25,6,25,9],[22,1,22,4]]}
[]
[]
[]
[]
[null,"Plantilla para cálculo de metas"]
[]
[null,"Datos del indicador"]
[]
[null,"Nombre del indicador:",null,null,null,null,{"$f":"PASO_1!$E$9","v":0}]
[null,"Nombre variable numerador:",null,null,null,null,{"$f":"PASO_1!$E$10","v":0}]
[null,"Nombre variable denominador:",null,null,null,null,{"$f":"PASO_1!$E$11","v":0}]
[null,"Método de cálculo",null,null,null,null,{"$f":"PASO_1!$E$12","v":0}]
[null,"Programa donde se le da seguimiento:",null,null,null,null,{"$f":"PASO_1!$E$13","v":0}]
[null,"Nivel del objetivo:",null,null,null,null,{"$f":"PASO_1!$E$14","v":0}]
[]
[null,"Método implementado para calcular meta"]
[]
[null,1,"¿Cuál fue la línea base seleccionada?",null,null,null,"Año",2021,"Varlor numerador",null,null,{"$f":"VLOOKUP(H18,Hoja2!H4:K16,2,0)","v":{"$error":"#N/A"}},"Varlor denominador",null,null,{"$f":"VLOOKUP(H18,Hoja2!H4:K16,3,0)","v":{"$error":"#N/A"}},"Resultado Indicador",null,{"$f":"VLOOKUP(H18,Hoja2!H4:K16,4,0)","v":{"$error":"#N/A"}}]
[]
[null,2,"¿Cuál fue el método utilizado para estimar la meta?",null,null,null,"Método incremental"]
[]
[]
[null,"Línea Base",null,null,null,null,"Meta estimada con método estadístico",null,null,null,null,{"$f":"P33","v":2024},null,"Meta estimada con otro método",null,null,null,null,{"$f":"P33","v":2024}]
[null,"Valor numerador",null,{"$f":"L18","v":{"$error":"#N/A"}},{"$f":"H18","v":2021},null,"Numerador",null,null,null,null,null,null,"Numerador",null,null,{"$f":"VLOOKUP(G20,Hoja2!D7:E9,2,0)","v":{"$error":"#N/A"}},{"$f":"Q24","v":{"$error":"#N/A"}}]
[null,"Valor denominador",null,{"$f":"P18","v":{"$error":"#N/A"}},null,null,"Denominador",null,null,null,null,null,null,"Denominador"]
[null,"Resultado indicador",null,{"$f":"S18","v":{"$error":"#N/A"}},null,null,"Meta del indicador \n(Valor relativo o valor absoluto)",null,null,null,{"$f":"P36","v":{"$error":"#DIV/0!"}},null,null,"Meta del indicador \n(Valor relativo o valor absoluto)"]
[]
[null,"Justificación de selección de meta por método alternativo"]
[]
[]
[null,null,null,"Visualizador gráfico de datos",null,null,null,null,null,null,null,null,null,null,null,"META con método estadístico","META con otro método"]
[]
[null,null,{"$f":"PASO_1!C49","v":0},{"$f":"PASO_1!D49","v":0},{"$f":"PASO_1!E49","v":0},{"$f":"PASO_1!F49","v":0},{"$f":"PASO_1!G49","v":0},{"$f":"PASO_1!H49","v":0},{"$f":"PASO_1!I49","v":0},{"$f":"PASO_1!J49","v":0},{"$f":"PASO_1!K49","v":0},{"$f":"PASO_1!L49","v":0},{"$f":"PASO_1!M49","v":0},{"$f":"PASO_1!N49","v":0},{"$f":"PASO_1!O49","v":0},{"$f":"PASO_1!P49","v":2024},{"$f":"PASO_1!P49","v":2024}]
[null,null,{"$f":"PASO_1!C50","v":0},{"$f":"PASO_1!D50","v":0},{"$f":"PASO_1!E50","v":0},{"$f":"PASO_1!F50","v":0},{"$f":"PASO_1!G50","v":0},{"$f":"PASO_1!H50","v":0},{"$f":"PASO_1!I50","v":0},{"$f":"PASO_1!J50","v":0},{"$f":"PASO_1!K50","v":0},{"$f":"PASO_1!L50","v":0},{"$f":"PASO_1!M50","v":0},{"$f":"PASO_1!N50","v":0},{"$f":"PASO_1!O50","v":0},null,{"$f":"S24","v":0}]
[null,null,{"$f":"PASO_1!C51","v":0},{"$f":"PASO_1!D51","v":0},{"$f":"PASO_1!E51","v":0},{"$f":"PASO_1!F51","v":0},{"$f":"PASO_1!G51","v":0},{"$f":"PASO_1!H51","v":0},{"$f":"PASO_1!I51","v":0},{"$f":"PASO_1!J51","v":0},{"$f":"PASO_1!K51","v":0},{"$f":"PASO_1!L51","v":0},{"$f":"PASO_1!M51","v":0},{"$f":"PASO_1!N51","v":0},{"$f":"PASO_1!O51","v":0},null,{"$f":"S25","v":0}]
[null,null,{"$f":"PASO_1!C52","v":0},{"$f":"PASO_1!D52","v":0},{"$f":"PASO_1!E52","v":0},{"$f":"PASO_1!F52","v":0},{"$f":"PASO_1!G52","v":0},{"$f":"PASO_1!H52","v":0},{"$f":"PASO_1!I52","v":0},{"$f":"PASO_1!J52","v":0},{"$f":"PASO_1!K52","v":0},{"$f":"PASO_1!L52","v":0},{"$f":"PASO_1!M52","v":0},{"$f":"PASO_1!N52","v":0},{"$f":"PASO_1!O52","v":0},{"$f":"VLOOKUP(G20,Hoja2!D4:E6,2,0)","v":{"$error":"#DIV/0!"}},{"$f":"S26","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Plantilla elaborada por el Departamento de Evaluación a partir de la información contenida en la Guía para el establecimiento y cálculo de línea base y metas del CONEVAL (pg. 19-33) https://www.coneval.org.mx/coordinacion/Documents/monitoreo/metodologia/guia_lineas_base_metas.pdf"]

{"sheet":"Tend_Ej.","index":8,"n_rows":33,"n_cols":27,"rows_kept":33,"cut":false,"hidden":false,"merged":[[10,19,11,19],[2,1,2,15],[15,2,19,3],[15,5,19,5],[15,6,16,6],[18,6,19,6],[15,14,16,14],[18,14,19,14],[16,15,18,15],[15,16,19,17],[15,11,19,11],[15,12,16,12],[18,12,19,12],[16,13,18,13],[5,1,6,1],[22,2,26,3],[22,5,26,5],[22,8,26,8],[15,8,19,8],[15,9,16,9],[18,9,19,9],[22,11,23,11],[25,11,26,11],[22,12,26,12],[22,6,26,6],[22,9,26,9],[23,13,25,13],[22,14,26,14],[23,15,25,15],[22,16,26,17],[21,16,21,17]]}
[]
[]
[null,"Método de tendencias (EJEMPLO)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"META",null,null,null,null,null,"Año","LB","Valor",null,"Meta","Año"]
["Capturar","Capturar años de los cuales se tienen valores",null,null,null,null,null,null,null,null,"2013","2014","2015","2016","2017",2018,null,null,null,null,null,{"$f":"$C$5","v":0},{"$f":"$C$9","v":0},{"$f":"$C$8","v":0},null,{"$f":"$C$10","v":0},{"$f":"$C$5","v":0}]
["Capturar","Capturar valores históricos del numerador y denominador. O si desea encontrar la meta estimada de un valor absoluto, deje en blanco estas casillas y sólo capture los valores en la siguiente fila.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$5","v":0},{"$f":"$D$9","v":0},{"$f":"$D$8","v":0},null,{"$f":"$D$10","v":0},{"$f":"$D$5","v":0}]
["Capturar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$5","v":0},{"$f":"$E$9","v":0},{"$f":"$E$8","v":0},null,{"$f":"$E$10","v":0},{"$f":"$E$5","v":0}]
["Capturar","Capturar valores históricos o aplicar fórmula",null,null,null,null,null,null,null,null,98.1,101.5,107.6,113.5,117.2,{"$f":"Q23","v":117.64},null,null,null,null,null,{"$f":"$F$5","v":0},{"$f":"$F$9","v":0},{"$f":"$F$8","v":0},null,{"$f":"$F$10","v":0},{"$f":"$F$5","v":0}]
["Capturar","Poner un 1 en la línea base",null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"$G$5","v":0},{"$f":"$G$9","v":0},{"$f":"$G$8","v":0},null,{"$f":"$G$10","v":0},{"$f":"$G$5","v":0}]
["Capturar","Poner un 1 debajo de la meta deseada",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,{"$f":"$H$5","v":0},{"$f":"$H$9","v":0},{"$f":"$H$8","v":0},null,{"$f":"$H$10","v":0},{"$f":"$H$5","v":0}]
["Capturar","Poner un 0 donde se seleccionó la LB, y capturar el valor consecutivo hacia atrás y hacia adelante debajo de los años donde haya valores",null,null,null,null,null,null,null,null,-2,-1,0,1,2,null,null,null,null,null,null,{"$f":"$I$5","v":0},{"$f":"$I$9","v":0},{"$f":"$I$8","v":0},null,{"$f":"$I$10","v":0},{"$f":"$I$5","v":0}]
["Capturar","Poner un \"1\" debajo de la LB, y poner un uno en las casillas subsecuentes hasta llegar al año de la meta deseada (también poner 1 debajo de la meta desada)",null,null,null,null,null,null,null,null,null,null,1,1,1,1,null,null,null,null,null,{"$f":"$J$5","v":0},{"$f":"$J$9","v":0},{"$f":"$J$8","v":0},null,{"$f":"$J$10","v":0},{"$f":"$J$5","v":0}]
[null,"Cálculos del numerador",{"$f":"C8*C11","v":0},0,0,{"$f":"F8*F11","v":0},0,0,0,0,-196.2,{"$f":"L8*L11","v":-101.5},0,113.5,234.4,0,null,null,null,null,null,{"$f":"$K$5","v":"2013"},{"$f":"$K$9","v":0},{"$f":"$K$8","v":98.1},null,{"$f":"$K$10","v":0},{"$f":"$K$5","v":"2013"}]
[null,"Cálculos del denominador",{"$f":"C11^2","v":0},0,0,{"$f":"F11^2","v":0},0,0,0,0,4,1,0,1,4,0,null,null,null,null,null,{"$f":"$L$5","v":"2014"},{"$f":"$L$9","v":0},{"$f":"$L$8","v":101.5},null,{"$f":"$L$10","v":0},{"$f":"$L$5","v":"2014"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$M$5","v":"2015"},{"$f":"$M$9","v":1},{"$f":"$M$8","v":107.6},null,{"$f":"$M$10","v":0},{"$f":"$M$5","v":"2015"}]
[null,null,null,null,null,null,{"$f":"SUM(C13:O13)","v":50.200000000000017},null,null,{"$f":"SUM(C12:P12)","v":4},null,null,{"$f":"G16","v":50.200000000000017},null,{"$f":"J16","v":4},null,{"$f":"((M16/M19)*(O16/O19))","v":10.040000000000003},null,null,null,null,{"$f":"$N$5","v":"2016"},{"$f":"$N$9","v":0},{"$f":"$N$8","v":113.5},null,{"$f":"$N$10","v":0},{"$f":"$N$5","v":"2016"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"*",null,"=",null,null,null,null,null,{"$f":"$O$5","v":"2017"},{"$f":"$O$9","v":0},{"$f":"$O$8","v":117.2},null,{"$f":"$O$10","v":0},{"$f":"$O$5","v":"2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$5","v":2018},{"$f":"$P$9","v":0},{"$f":"$P$8","v":117.64},null,{"$f":"$P$10","v":1},{"$f":"$P$5","v":2018}]
[null,null,null,null,null,null,{"$f":"SUM(C14:O14)","v":10},null,null,2,null,null,{"$f":"G19","v":10},null,{"$f":"J19","v":2}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meta estimada"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(1,$W$5:$X$18,2,0)","v":107.6},null,null,{"$f":"$Q$16","v":10.040000000000003},null,null,{"$f":"$G$23","v":107.6},null,{"$f":"$J$23","v":10.040000000000003},null,{"$f":"M23+O23","v":117.64}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"="]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(1,$Z$5:$AA$18,2,0)","v":2018}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(D32, L25)","v":"𝑦 ̂2018"}]
[]
[]
[]
[]
[null,null,null,"∆","Cambio estimado del periodo de referencia",null,null,null,"𝑦𝑏𝑎𝑠𝑒","Valor del indicador en el año base"]
[null,null,null,"𝑦 ̂","Valor del indicador esimado como meta",null,null,null,"z","Valor de tiempo según año base"]
[null,null,null,"𝑦","Valor del indicador",null,null,null,"n","Número de años desde el año base hasta el año a estimar"]

{"sheet":"Incr_Ej.","index":9,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[[27,13,31,14],[27,4,31,6],[27,9,31,9],[28,10,30,10],[27,11,31,11],[27,8,31,8],[28,12,30,12],[20,2,24,4],[20,6,21,6],[23,6,24,6],[20,7,24,7],[20,9,24,10],[26,13,26,14],[20,11,24,11],[20,13,24,13],[20,15,24,16],[16,6,17,6],[21,12,23,12],[21,14,23,14],[14,7,16,7],[2,1,2,15],[10,19,11,19],[13,2,17,3],[13,5,17,5],[13,6,14,6],[13,8,17,8]]}
[]
[]
[null,"Método Incremental (EJEMPLO)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"META",null,null,null,null,null,null,"Meta","Año"]
["Capturar","Capturar años de los cuales se tienen valores",null,null,null,null,null,null,null,null,"2013","2014","2015","2016","2017",2018,null,null,null,null,null,null,{"$f":"$C$10","v":0},{"$f":"$C$5","v":0}]
["Capturar","Capturar valores históricos del numerador",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,{"$f":"$D$10","v":0},{"$f":"$D$5","v":0}]
["Capturar","Capturar históricos del denominador",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,{"$f":"$E$10","v":0},{"$f":"$E$5","v":0}]
["Capturar","Capturar valores históricos o aplicar fórmula",null,null,null,null,null,null,null,null,58.4,57.8,58,57.1,56.9,{"$f":"N28","v":56.532516565741048},null,null,null,null,null,null,{"$f":"$F$10","v":0},{"$f":"$F$5","v":0}]
["Capturar","Poner un 1 en la línea base",null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,{"$f":"$G$10","v":0},{"$f":"$G$5","v":0}]
["Capturar","Poner un 1 debajo de la meta deseada",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"$H$10","v":0},{"$f":"$H$5","v":0}]
[null,null,{"$f":"IF(C8, ((D8/C8)-1), \" \")","v":" "},{"$f":"IF(D8, ((E8/D8)-1), \" \")","v":" "},{"$f":"IF(E8, ((F8/E8)-1), \" \")","v":" "}," "," "," "," "," ",-1.0273972602739767E-2,3.4602076124568004E-3,-1.551724137931032E-2,-3.5026269702277402E-3,"x","x",null,null,null,null,null,null,{"$f":"$I$10","v":0},{"$f":"$I$5","v":0}]
[null,"T",{"$f":"COUNT(C11)","v":0},{"$f":"COUNT(D11)","v":0},{"$f":"COUNT(E11)","v":0},0,0,0,0,0,1,1,1,1,"x","x",null,null,null,null,null,null,{"$f":"$J$10","v":0},{"$f":"$J$5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$K$10","v":0},{"$f":"$K$5","v":"2013"}]
[null,null,null,null,null,null,{"$f":"SUM(C11:N11)","v":-2.5833633339821027E-2},null,{"$f":"G14/G17","v":-6.4584083349552568E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$L$10","v":0},{"$f":"$L$5","v":"2014"}]
[null,null,null,null,null,null,null,"=",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$M$10","v":0},{"$f":"$M$5","v":"2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$N$10","v":0},{"$f":"$N$5","v":"2016"}]
[null,null,null,null,null,null,{"$f":"SUM(C12:N12)","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$10","v":0},{"$f":"$O$5","v":"2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$10","v":1},{"$f":"$P$5","v":2018}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"LOOKUP(MAX(C8:O8)+1, C8:O8, C8:O8)","v":56.9},null,null,null,{"$f":"$I$14","v":-6.4584083349552568E-3},null,1,null,{"$f":"L21+N21","v":0.99354159166504474}]
[null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"="]
[null,null,null,null,null,null,{"$f":"VLOOKUP(1,$W$5:$X$18,2,0)-1","v":2017}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(D37, G23)","v":"𝑦 ̂2017"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Meta estimada"]
[null,null,null,null,null,null,null,null,null,{"$f":"H21","v":56.9},null,{"$f":"P21","v":0.99354159166504474},null,{"$f":"J28*L28","v":56.532516565741048}]
[null,null,null,null,null,null,null,null,null,null,"*",null,"="]
[]
[]
[]
[]
[]
[null,null,null,"∆","Tasa de variación de las observaciones",null,null,null,"y1, y0","Observaciones del indicador en diferentes periodos de tiempo"]
[null,null,null,"Δ ̅","Promedio de tasa de variación",null,null,null,"T","Número total de tasas de variaciones (número de periodos de los que se tiene información menos 1)"]
[null,null,null,"𝑦 ̂","Valor estimado como meta",null,null,null,"Yt-1","Valor del periodo inmediato anterior al que se estimará como meta"]

{"sheet":"Lineal_Ej.","index":10,"n_rows":44,"n_cols":24,"rows_kept":44,"cut":false,"hidden":false,"merged":[[34,13,38,13],[35,7,37,7],[35,9,37,9],[33,12,33,13],[34,2,38,3],[34,5,38,5],[34,6,38,6],[34,8,38,8],[34,10,38,10],[34,12,38,12],[22,15,24,15],[21,16,25,16],[27,2,31,3],[27,5,31,5],[27,6,31,6],[28,7,30,7],[28,9,30,9],[27,10,31,10],[27,12,31,12],[27,13,31,13],[21,13,22,13],[21,12,22,12],[21,14,22,14],[24,10,25,10],[24,11,25,11],[24,12,25,14],[21,6,25,6],[27,8,31,8],[21,2,25,4],[21,10,22,10],[21,11,22,11],[21,7,22,8],[24,7,25,8],[21,9,22,9],[24,9,25,9],[2,1,2,15],[10,19,11,19],[15,2,19,3],[15,8,19,8],[15,13,19,13],[15,14,16,14],[15,5,19,6],[15,9,16,9],[18,9,19,9],[16,10,18,10],[15,11,19,11],[15,16,19,16],[16,15,18,15],[18,14,19,14]]}
[]
[]
[null,"Extrapolación Lineal (EJEMPLO)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"META",null,null,null,null,null,null,"Meta","Año"]
["Capturar","Capturar años de los cuales se tienen valores",null,null,null,null,null,null,null,null,2013,2014,2015,2016,2017,2018,null,null,null,null,null,null,{"$f":"$C$10","v":0},{"$f":"$C$5","v":0}]
["Capturar","Capturar valores históricos del numerador",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,{"$f":"$D$10","v":0},{"$f":"$D$5","v":0}]
["Capturar","Capturar históricos del denominador",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,{"$f":"$E$10","v":0},{"$f":"$E$5","v":0}]
["Capturar","Capturar valores históricos o aplicar fórmula",null,null,null,null,null,null,null,null,5.3,null,4.9000000000000004,4.8,4.7,{"$f":"N35","v":4.5085714285723384},null,null,null,null,null,null,{"$f":"$F$10","v":0},{"$f":"$F$5","v":0}]
["Capturar","Poner un 1 en la línea base",null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,{"$f":"$G$10","v":0},{"$f":"$G$5","v":0}]
["Capturar","Poner un 1 debajo de la meta deseada",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"$H$10","v":0},{"$f":"$H$5","v":0}]
[null,null,{"$f":"IF(C8, (C5*C8), \" \")","v":" "},{"$f":"IF(D8, (D5*D8), \" \")","v":" "}," ",null,null,null,null,null,10668.9," ",9873.5,9676.7999999999993,9479.9,null,null,null,null,null,null,null,{"$f":"$I$10","v":0},{"$f":"$I$5","v":0}]
[null,"n",{"$f":"COUNT(C8)","v":0},0,0,null,null,null,null,null,1,0,1,1,1,null,null,null,null,null,null,null,{"$f":"$J$10","v":0},{"$f":"$J$5","v":0}]
[null,"Años con datos",{"$f":"C5*C12","v":0},{"$f":"D5*D12","v":0},0,null,null,null,null,null,2013,0,2015,2016,2017]
[null,null,{"$f":"C13^2","v":0},{"$f":"D13^2","v":0},0,null,null,null,null,null,4052169,0,4060225,4064256,4068289]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$K$10","v":0},{"$f":"$K$5","v":2013}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(C8:O8)","v":19.7},null,{"$f":"J16/J19","v":4.9249999999999998},null,null,{"$f":"SUM(C13:O13)","v":8061},null,{"$f":"O16/O19","v":2015.25},null,null,null,null,null,{"$f":"$L$10","v":0},{"$f":"$L$5","v":2014}]
[null,null,null,null,null,null,null,null,null,null,"=",null,null,null,null,"=",null,null,null,null,null,null,{"$f":"$M$10","v":0},{"$f":"$M$5","v":2015}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$N$10","v":0},{"$f":"$N$5","v":2016}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(C12:O12)","v":4},null,null,null,null,{"$f":"SUM(C12:O12)","v":4},null,null,null,null,null,null,null,{"$f":"$O$10","v":0},{"$f":"$O$5","v":2017}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$10","v":1},{"$f":"$P$5","v":2018}]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(C11:O11)","v":39699.1},null,"-",{"$f":"SUM(C12:O12)","v":4},"*",{"$f":"Q16","v":2015.25},"*",{"$f":"L16","v":4.9249999999999998},null,{"$f":"((H22-(K22*M22*O22))/(H25-(K25*M25)))","v":-0.15142857142823882}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"="]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(C14:O14)","v":16244939},null,"-",{"$f":"K22","v":4},"*",{"$f":"Q16^2","v":4061232.5625}]
[]
[]
[null,null,null,null,null,null,{"$f":"L16","v":4.9249999999999998},null,{"$f":"Q22","v":-0.15142857142823882},null,{"$f":"Q16","v":2015.25},null,null,{"$f":"(G28-(I28*K28))","v":310.0914285707583}]
[null,null,null,null,null,null,null,"-",null,"*"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Meta deseada"]
[null,null,null,null,null,null,{"$f":"N28","v":310.0914285707583},null,{"$f":"Q22","v":-0.15142857142823882},null,{"$f":"VLOOKUP(1,$W$5:$X$20,2,0)","v":2018},null,null,{"$f":"(G35+(I35*K35))","v":4.5085714285723384}]
[null,null,null,null,null,null,null,"+",null,"*"]
[]
[]
[]
[]
[null,null,null,"𝑦 ̂","Es el valor estimado de la meta.",null,null,null,"y","Es el valor de las observaciones del indicador"]
[null,null,null,"a","Es el valor del origen de la recta.",null,null,null,"𝑥 ̅","Es el promedio de la variable x."]
[null,null,null,"b","Es el valor de la pendiente de la recta.",null,null,null,"𝑦 ̅","Es el promedio de la variable y."]
[null,null,null,"x","Es el valor que corresponde al periodo.",null,null,null,"n","Es el número de observaciones."]

{"sheet":"Hoja2","index":11,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"Tipos de métodos para definir meta"]
[null,null,null,"Método de tendencias",{"$f":"Tend.!P15","v":{"$error":"#N/A"}},null,null,{"$f":"PASO_1!$C49","v":0},{"$f":"PASO_1!$C50","v":0},{"$f":"PASO_1!$C51","v":0},{"$f":"PASO_1!$C52","v":0}]
[null,null,null,"Método incremental",{"$f":"Incr.!P15","v":{"$error":"#DIV/0!"}},null,null,{"$f":"PASO_1!$D49","v":0},{"$f":"PASO_1!$D50","v":0},{"$f":"PASO_1!$D51","v":0},{"$f":"PASO_1!$D52","v":0}]
[null,null,null,"Método lineal",{"$f":"Lineal!P15","v":{"$error":"#DIV/0!"}},null,null,{"$f":"PASO_1!$E49","v":0},{"$f":"PASO_1!$E50","v":0},{"$f":"PASO_1!$E51","v":0},{"$f":"PASO_1!$E52","v":0}]
[null,null,null,"Referente internacional","CAPTURAR",null,null,{"$f":"PASO_1!$F49","v":0},{"$f":"PASO_1!$F50","v":0},{"$f":"PASO_1!$F51","v":0},{"$f":"PASO_1!$F52","v":0}]
[null,null,null,"Método Delphi","CAPTURAR",null,null,{"$f":"PASO_1!$G49","v":0},{"$f":"PASO_1!$G50","v":0},{"$f":"PASO_1!$G51","v":0},{"$f":"PASO_1!$G52","v":0}]
[null,null,null,"Método alternativo","CAPTURAR",null,null,{"$f":"PASO_1!$H49","v":0},{"$f":"PASO_1!$H50","v":0},{"$f":"PASO_1!$H51","v":0},{"$f":"PASO_1!$H52","v":0}]
[null,null,null,null,null,null,null,{"$f":"PASO_1!$I49","v":0},{"$f":"PASO_1!$I50","v":0},{"$f":"PASO_1!$I51","v":0},{"$f":"PASO_1!$I52","v":0}]
[null,null,null,null,null,null,null,{"$f":"PASO_1!$J49","v":0},{"$f":"PASO_1!$J50","v":0},{"$f":"PASO_1!$J51","v":0},{"$f":"PASO_1!$J52","v":0}]
[null,null,null,null,null,null,null,{"$f":"PASO_1!$K49","v":0},{"$f":"PASO_1!$K50","v":0},{"$f":"PASO_1!$K51","v":0},{"$f":"PASO_1!$K52","v":0}]
[null,null,null,null,null,null,null,{"$f":"PASO_1!$L49","v":0},{"$f":"PASO_1!$L50","v":0},{"$f":"PASO_1!$L51","v":0},{"$f":"PASO_1!$L52","v":0}]
[null,null,null,null,null,null,null,{"$f":"PASO_1!$M49","v":0},{"$f":"PASO_1!$M50","v":0},{"$f":"PASO_1!$M51","v":0},{"$f":"PASO_1!$M52","v":0}]
[null,null,null,null,null,null,null,{"$f":"PASO_1!$N49","v":0},{"$f":"PASO_1!$N50","v":0},{"$f":"PASO_1!$N51","v":0},{"$f":"PASO_1!$N52","v":0}]
[null,null,null,null,null,null,null,{"$f":"PASO_1!$O49","v":0},{"$f":"PASO_1!$O50","v":0},{"$f":"PASO_1!$O51","v":0},{"$f":"PASO_1!$O52","v":0}]

{"sheet":"Hoja9","index":12,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Completa","Se puede utilizar alguno de estos métodos para estimar la meta","Método de tendencias","El método de tendencias permite realizar análisis de las observaciones pasadas y generar valores futuros, a partir de la tendencia observada. En particular, este método se basa en la tendencia de los datos en los periodos anteriores al que se desea pronosticar. \n\nLa estimación por este método se realiza en dos etapas; primero, se calcula el cambio esperado, considerando la tendencia de los datos y un periodo base, posteriormente con este se calcula el valor proyectado, el cual servirá como meta \n\nEl uso del método de tendencias se recomienda cuando se cuenta con una serie de observaciones pasadas y se necesita realizar una estimación del valor del indicador a futuro. En ese sentido, vale la pena tomar en consideración lo siguiente:\n\n1. Las observaciones deben tener la misma periodicidad y ser equidistantes.\n2. Se debe contar con observaciones inmediatas anteriores al periodo a estimar. No deben existir huecos de información.","Método incremental","Es un método estadístico utilizado para la proyección de valores futuros, y que al igual que el método de tendencias, utiliza información pasada del indicador. El método incremental se basa en las variaciones promedio de la información de periodos anteriores. Para implementarlo, primero se calculan las tasas de variación de las observaciones anteriores; posteriormente se obtiene su promedio, y finalmente, con estos resultados, se estima la meta. \n\nEl uso del método incremental se recomienda cuando las observaciones de los indicadores no cuentan con una tendencia clara, es decir, los datos podrían tener una trayectoria errática. Al utilizar esta técnica, es necesario considerar lo siguiente:\n \n1. Los datos podrían no presentar una tendencia ascendente. Si bien el método se denomina incremental, las observaciones para su cálculo no necesariamente deben presentar esa tendencia. Al generalizar los cambios de las observaciones, el método puede ser usado para distintos escenarios. \n\n2. Se requiere el mayor número de observaciones posibles. Para lograr una estimación más acertada del valor a pronosticar, se requiere el uso del mayor número de observaciones posible. Si se tiene un número reducido de observaciones, el valor estimado podría no ser representativo del valor que se busca aproximar.\n\n3. Las observaciones deben tener la misma periodicidad y ser equidistantes."]
[null,null,"Incompleta","Se puede utilizar alguno de estos métodos para estimar la meta","Método lineal","La extrapolación lineal es un método que se basa en el conocimiento a priori de las observaciones existentes y se usa para estimar cómo se comportará la observación faltante o futura. La aplicación de este método tiene como objetivo estimar la ecuación de la recta para predecir el comportamiento futuro de un indicador; para ello, es necesario calcular la pendiente (b) y ordenada al origen de la recta (a). Finalmente, con esos datos es posible estimar el valor de la meta (y� ̂). \n\nEl uso de la extrapolación lineal se recomienda en escenarios donde se cuenta con cierta información histórica del indicador en cuestión y se necesita hacer un pronóstico. Para poder hacer uso de la extrapolación lineal, se deben tomar en cuenta las siguientes condiciones:\n\n1. Los datos deben mostrar una tendencia lineal. Al hacer una gráfica de dispersión con las observaciones de periodos anteriores, estos deben mostrar necesariamente una tendencia cercana o igual a la lineal. \n2. Las observaciones deben mantener la misma periodicidad y ser equidistantes. \n3. Se debe tener información de observaciones cercanas a la que se pretende estimar. Para la estimación de metas de mediano y largo plazo, (como sexenales). se podría realizar una extrapolación si se cuenta con al menos la misma cantidad de observaciones pasadas de las que se quieren pronosticar.\n4. Se debe considerar la mayor cantidad de información posible. Se debe verificar que los datos faltantes no correspondan a observaciones consecutivas.","Referente internacional"," Se propone que la definición de metas a partir de agendas internacionales siga un análisis comparativo de las condiciones con otros países. Para realizar un análisis comparativo y poder establecer una meta, se sugiere seguir, como mínimo los siguientes pasos: \n\n1. Selección del indicador a comparar. Una vez establecido lo que se quiere medir, se debe realizar una revisión de la literatura internacional en la cual se indaguen posibles indicadores que den cuenta del objetivo. Los indicadores por comparar deben mantener ciertas características comunes a través de las regiones que refieren su comparación; por ejemplo, fórmulas de cálculo y periodicidad homogéneas.\n2. Selección de posibles regiones o países para su comparación. La selección debe considerar países o regiones con características similares o mejores condiciones que las del país en referencia, estableciendo como meta lo alcanzado por los otros países.\n3. Análisis de los resultados del indicador.  Una vez que se definió la comparabilidad del indicador, es posible revisar los resultados que obtuvieron los países o regiones seleccionados. En este punto se recopila y revisa la información más reciente del indicador.\n4. Valoración de las capacidades de la intervención. Es necesario hacer una reflexión de los alcances de la intervención. A través del conocimiento de sus recursos humanos, financieros, materiales, entre otros, se debe hacer un análisis prospectivo de los logros que se esperan alcanzar.\n5. Selección de la meta a alcanzar. Derivado de la revisión se obtiene una serie de posibles metas a elegir, además de contar con diferentes expectativas de la propia intervención."]
[null,null,"Inexistente","Se puede utilizar alguno de estos métodos para estimar la meta","Método Delphi","El estudio Delphi es una técnica prospectiva de naturaleza subjetiva, la cual, busca un consenso entre un grupo de expertos a través de encuestas o cuestionarios sucesivos sobre algún tema en particular. \n\nEste método se utiliza cuando no se puede emplear información objetiva, o bien, que al momento no puede ser medible o que el medirla resulta demasiado costoso. Por otro lado, se caracteriza por ser un proceso iterativo, en el cual se mantiene el anonimato de los participantes y en el que todas las opiniones forman parte de una respuesta final. \n\nSi bien el uso de esta técnica está más relacionado con los análisis cualitativos, se puede emplear en procesos que necesiten conocer la probabilidad del logro de metas, o incluso para su posible ajuste. \n","Método alternativo ","Aunque de manera informal, si la relevancia del indicador lo permite, se puede estimar una meta con base en información interna, experiencia del personal, entre otras, para que con la información generada durante el primer año pueda definirse una meta más acertada para el segundo año."]